using System;
using System.Collections.Generic;
using System.Text;
using System.Data;



namespace THSLib
{
    #region STTHSCommandParametersController
    /// <summary>
    /// This object represents the properties and methods of a THSCommandParameter.
    /// </summary>
    public class STTHSCommandParametersController:BaseBusinessController
    {
        #region SP Name
        
        //Select By ForeignKey Queries
        private readonly string spGetSTTHSCommandParametersBySTTHSDataTableID = "STTHSCommandParameters_SelectBySTTHSDataTableID";
        //Delete by foreignkey Queries
        
        /*Remove cause of not use
        private readonly string spDeleteSTTHSCommandParametersBySTTHSDataTableID = "STTHSCommandParameters_DeleteBySTTHSDataTableID";*/

        #endregion

        public STTHSCommandParametersController()
        {
            //dal = new STTHSCommandParametersDAL();
            dal = new DALBaseProvider("STTHSCommandParameters", typeof(STTHSCommandParametersInfo));
        }       
        

        public DataSet GetTHSCommandParameterByTHSDataTableID(int iTHSDataTableID)
        {
            return (DataSet)dal.GetDataSet(spGetSTTHSCommandParametersBySTTHSDataTableID, iTHSDataTableID);            
        }
    }
    #endregion
}
